Year-to-Date Transaction Open (GL20000)

SELECT
       ['Year-to-Date Transaction Open'].SOURCDOC AS 'Year-to-Date Transaction Open-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Year-to-Date Transaction Open'].SOURCDOC = ['Source Document Master'].SOURCDOC

SELECT
       ['Year-to-Date Transaction Open'].ACTINDX AS 'Year-to-Date Transaction Open-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Year-to-Date Transaction Open'].ACTINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Year-to-Date Transaction Open'].LASTUSER AS 'Year-to-Date Transaction Open-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Year-to-Date Transaction Open'].LASTUSER = ['Users Master'].USERID

SELECT
       ['Year-to-Date Transaction Open'].USWHPSTD AS 'Year-to-Date Transaction Open-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Year-to-Date Transaction Open'].USWHPSTD = ['Users Master'].USERID

SELECT
       ['Year-to-Date Transaction Open'].ORCTRNUM AS 'Year-to-Date Transaction Open-Originating Control Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Year-to-Date Transaction Open'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM

SELECT
       ['Year-to-Date Transaction Open'].ORMSTRID AS 'Year-to-Date Transaction Open-Originating Master ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Year-to-Date Transaction Open'].ORMSTRID = ['PM Vendor Master File'].VENDORID

SELECT
       ['Year-to-Date Transaction Open'].CURNCYID AS 'Year-to-Date Transaction Open-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Year-to-Date Transaction Open'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Year-to-Date Transaction Open'].CURRNIDX AS 'Year-to-Date Transaction Open-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Year-to-Date Transaction Open'].CURRNIDX = ['Currency Setup'].CURRNIDX

SELECT
       ['Year-to-Date Transaction Open'].RATETPID AS 'Year-to-Date Transaction Open-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Year-to-Date Transaction Open'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID

SELECT
       ['Year-to-Date Transaction Open'].EXGTBLID AS 'Year-to-Date Transaction Open-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Year-to-Date Transaction Open'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID

SELECT
       ['Year-to-Date Transaction Open'].NOTEINDX AS 'Year-to-Date Transaction Open-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Year-to-Date Transaction Open'].NOTEINDX = ['Record Notes Master'].NOTEINDX

0	Not intercompany.
1	Intercompany

SELECT
       ['Year-to-Date Transaction Open'].ORCOMID AS 'Year-to-Date Transaction Open-Originating Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Year-to-Date Transaction Open'].ORCOMID = ['Company Master'].CMPANYID

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.

SELECT
       ['Year-to-Date Transaction Open'].APRVLUSERID AS 'Year-to-Date Transaction Open-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL20000 AS ['Year-to-Date Transaction Open']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Year-to-Date Transaction Open'].APRVLUSERID = ['Users Master'].USERID